﻿

--添加奖惩
CREATE proc [dbo].[proc_Employee_Award_Punish_Update]
(
	@AContent nvarchar(MAX),
	@Reason NVARCHAR(MAX),
	@EntryPeople nvarchar(50),
	@EntryTime DATETIME,	
	@Temp INT,
	@Id int
)
AS
	DECLARE @UName NVARCHAR(20)
	SET @UName=(SELECT EName FROM Employee WHERE UserName=@EntryPeople)	
	IF(@UName is NULL)
	set @UName=@EntryPeople
	UPDATE Award_Punish SET AContent=@AContent,Reason=@Reason,EntryPeople=@EntryPeople,EntryTime=@EntryTime,Temp=@Temp WHERE Id=@Id
RETURN 

